Macro 20photography Projects

Excel Automation Expert to configure data

This is a very simple task, shouldn't take to long to do. I need an Excel expert to configure an automatically updating transaction statement in my spreadsheet. The spreadsheet contains two sheets: Sales and Expenses. I want a third sheet called Transaction Statement to pull and combine data from both, updating itself when I add new entries. Scope of Work: 1. Extract from Sales Sheet: Columns needed: DATE PAID, CUSTOMER NAME, and TOTAL AMOUNT. Map to: Date → DATE PAID Name → CUSTOMER NAME Incoming (£) → TOTAL AMOUNT Outgoing (£) → Leave as 0 2. Extract from Expenses Sheet: Columns needed: DATE PAID, SUPPLIER NAME, and TOTAL AMOUNT. Map to: Date → DATE PAID Name → SUPPLIER NAME Outgoing (£) → TOTAL AMOUNT Incoming (£) → Leave as 0 3. Create Transaction Statement Sheet: Combine both data sets into a single sheet. Sort the data by Date (like a bank statement). Ensure the sheet updates automatically when new rows are added to either the Sales or Expenses sheet. 4. Automation Options (any of the following): Power Query (preferred if no macros needed) VBA Script/Macro (if Power Query is not suitable) Any other seamless Excel solution

Personal Project

Someone that is very good with vba macro programming. In the example file I attached you can see sequences of numbers with different colour asterisks next to. What I need is for you to programme it to look for the sequences and when a particular sequences appears it activates the particular colour asterix. There is other programming bits involved which can be talked about later because I don't want to complicate it too much right at the begenning.

SQL - Excel Macro

Hi Hope you are well. I have an excel with a Macro that links to SQL and does some calculations using 3 tables of data in SQL and then keeps the data in SQL in a new table. 1. this macro has stopped working due to "ADODB.Recordset" issue. 2. the macro produces monthly account balances from inception to now and I would like to adjust this to be based on a start date and not all of the history. If you believe you can help with these two issues can you please let me know. Many thanks Robert

Excel to Google Sheets Conversion for Production Planning Tool

Project Scope: Excel to Google Sheets Conversion for Production Planning Tool We need to convert a complex, multi-sheet Excel-based production planner (with macros and PowerQueries) into a fully functional Google Sheets solution. This is used for tracking furniture manufacturing orders. The new Google Sheets version should replicate all current functionality and also allow for some additional improvements or enhancements. Key Requirements: Convert Excel Macros & PowerQueries to Google Sheets-compatible functions (likely using Google Apps Script). Maintain and recreate existing functionality, including: Dynamic data entry Conditional formatting Automated data movement between sheets Custom charts and graphs Gantt charts Allow for future enhancements or process improvements. Sheet Breakdown: SHEET 1: Active Orders Tracks all current product orders. Each row = one product SKU in production. Includes: client details, production schedule, departments involved, tracking for each production stage, and financial graphs. SHEET 2: Completed Orders Orders marked complete move here. Used for historical tracking, performance metrics, and visual analysis (e.g., lead times, dollar value by week). SHEET 3: Products Product master list. Defines production steps per product and expected build times for each department. SHEETS 4–15: Work Center Sheets One sheet per production stage (e.g., Parts, Sanding, Finishing). Pulls relevant orders from “Active Orders”. Allows team to input actual build times and completion dates, which update back to Sheet 1. Sheet 16–17: Gantt Charts Visual schedules by builder for key departments (Custom Shop, Upper Assembly). Ideal Provider: Proficient in Google Sheets and Apps Script Experience with migrating Excel macros to Google Sheets Understanding of manufacturing workflows is a plus

Build Excel Template to Extract from Source Sheet (No Macros)

I need an Excel template that allows automatic extraction of Index and Population data from a pasted dataset. The source data will always follow the same format but may vary in size (rows/columns). Multiple sample datasets will be provided for testing. Requirements: • A “Raw Data” sheet where the user pastes new source data each time • One or two extraction sheets: • Option A: A single extraction sheet with filters (preferred) showing both Index and Population for ease of analysis • Option B: Two separate extraction sheets — one for Index, one for Population — if filtering becomes difficult in a combined view • The extraction sheet(s) should update automatically upon pasting new data in the source • Must handle moderate variation in row and column counts • No macros or VBA • Use standard Excel tools only (e.g., formulas, pivot tables, filters) • Layout must be clean, user-friendly, and easy to read Sample datasets will be provided to test accuracy and adaptability.

Van stock management excel sheet

We need a multi-tab Excel or Google Sheets system to manage van stock, material usage, and restocking across 5–10 mobile traders. Each trader must have a separate tab. The system must include: Van Stock Tabs: One van stock tab per trader Expected quantity vs current stock "Used This Week" tracking Automatic "Restock Needed" flags Cost per item and calculated weekly cost per trader Supplier link for each material (optional column with URL to Screwfix/Toolstation) Usage Log: Combined Usage Log tab (filled from daily WhatsApp messages) Columns: Date, Trader, Job ID (optional), Materials Used Weekly Summary: Weekly Summary tab showing: Total materials used per trader Weekly material costs Items needing restock Dashboard Tab: Overview of all low stock items across all traders Weekly usage report per trader Visual alerts for shortages and restocking priorities Total material cost per week per trader Color-coded formatting for visibility Monthly Summary: Monthly usage totals per trader Total cost of materials per trader Most used items per trader each month Archiving & Reset Functionality: Ability to reset "Used This Week" every Monday (manually or via button) Archive tab or export system to save each week’s summary for future reference Option to refill/recover previous week’s data if needed Structure & Formatting: Easy-to-duplicate trader tabs for future team expansion Protected formulas and locked layout to prevent accidental edits Google Sheets compatible (no Excel-only features or macros) Please let us know your availability

opportunity

Create a pricing calculator

We use a complex excel spreadsheet (it uses macros) to price up jobs for our customers and it also allows us to generate a PDF quote. It is currently used on a desktop. I would like a new software version creating that has the following functionality: Able to be used on a tablet as well as a desktop and it work when online and offline (I don't always have wifi signal when on site). For us to be able to easily update the prices associated with the material and installation costs. For us to be able to load up a previous input and change and resave it as a new version. For the output to be in pdf format and with an attractive appearance so it can be sent to our customers as a quote. I have had to upload in .xls format so some of the functionality probably won't work. I can email a .xlsm version on request.

opportunity

Someone with experience using Macro Active to upload workouts

I am looking for someone with specific experience using the macro active fitness platform to categorise my workout programmes and ensure all my fitness videos are organised within the app. I also need this person to upload pre prepared recipes I have created. MUST have experience using macro active. Thanks!

opportunity

Develop a Pricing table for Sales Team with Margin calculators

Freelance Excel Specialist Needed – Multi-Currency Pricing Table with SKU Images & Search Functionality We are looking for an Excel expert to develop a comprehensive pricing tool for our sales team, covering approximately 200 SKUs across three currencies (GBP, USD, EUR). This tool must streamline price calculations, display product images, and allow for quick searches by product name. Project Scope: ✅ Three Currency Sheets – Separate pricing sheets for GBP, USD, and EUR, with automatic currency conversion. ✅ Dynamic SKU Pricing – Automated calculations based on materials, customizations, and quantity. ✅ Image Integration – Ability to display product images next to SKUs. ✅ Search Functionality – Quick search/filtering by product name for easy navigation. ✅ Cost & Margin Calculation – Include built-in profitability metrics (cost, margin, and contribution calculations). ✅ User-Friendly Interface – Dropdown selections, conditional formatting, and structured layout for ease of use. Ideal Candidate: ✔ Proficient in Excel (advanced formulas, data validation, pivot tables). ✔ Experience with large datasets (handling 200+ SKUs efficiently). ✔ Knowledge of image embedding in Excel (linking or displaying product visuals). ✔ VBA/macros experience is a plus for automation and enhanced functionality.

Format excel sheet for google contacts and google earth export

have a small Excel sheet with addresses and phone numbers which I need to import into Google contacts. This I would like to learn myself and would like to work on the sheet on Teams. It comes down to the headings but having issues two other things I would like is to prepare the same sheet to export to googel earth Also on this sheet each address has 4 steps to complete the project so some form of macro to show the current status I cant send the file due to GDPR hoping to have this done asap

Format excel sheet for google contacts and google earth export

I need to import a small Excel sheet with addresses and phone numbers into Google contacts. This I would like to learn myself and would like to work on the sheet on Teams. It comes down to the headings but having issues two other things I would like is to prepare the same sheet to export to Google Earth Also on this sheet each address has 4 steps to complete the project so some form of macro to show the current status I cant send the file due to GDPR hoping to have this done asap

Excel sheet reconciliation

Automating weekly Excel report reconciliation through effective formula usage. The core task involves reconciling numbers across spreadsheets on a weekly basis through manual data entry and calculations. The goal is to enhance efficiency and reduce redundancies by leveraging Excel's powerful functionalities like SUMIF, COUNTIF, VLOOKUP etc. Experience with advanced formulas, Pivot Tables and automation through Macros is required. Bidders should detail process of analyzing current manual steps and improving it through formula-driven approach to automatically fetch, calculate and reconcile data with minimal human intervention weekly. Knowledge of best practices for task repetition and automation in Excel will be an added advantage. Important note is that my laptop is protected by company so I cannot use Copilot in my laptop.

Excel VBA Macro Fix Required

We have a macro in one of our Excel spreadsheets (Office 365) that is not functioning correctly. The macro imports all the data from one tab of spreadsheet B into a tab of Spreadsheet A, and moves/formats the required information in sheet A into another tab, combining incoming stock numbers and dates. We need a VBA expert to modify our existing macro so it works correctly. It should be quite a quick fix for someone with the right knowledge of VBA.

opportunity

VBA Devloppment

I am reaching out for your expertise to develop a VBA macro that will automate the management of an interactive form in Microsoft Word. Below are the details of my request and the expected outcomes. Context: I am working with a Word (.dotx) template used to generate personalized offers. This template includes specific tags for managing optional sections and merge fields for inserting dynamic data. The tags in the document are as follows: [COMMUN]: Sections common to all offers. [OPTION ...]: Tags indicating optional sections (complete list below). The merge fields to be handled are: [DATE VALIDITE]: A date in the format DD/MM/YYYY. [NOM_CLIENT]: The client's name. [PROJET]: The project type. Request: I would like a VBA macro that automates the following tasks: Dynamic UserForm creation: The form should include: Checkboxes for each optional section (tags [OPTION ...]). TextBoxes for the merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET]. A button to validate the user's choices and apply the changes to the document. Management of optional sections: Based on the checkboxes selected in the form, the corresponding sections should be included or removed from the document. Merge field replacement: The form's text fields should allow the user to input values that will replace [DATE VALIDITE], [NOM_CLIENT], and [PROJET] in the document. Expected Outcome: An interactive UserForm: Displays checkboxes for each [OPTION ...] tag present in the document. Contains text fields to populate the merge fields. A personalized document: Sections corresponding to [OPTION ...] tags are included/excluded based on the form selections. Merge fields [DATE VALIDITE], [NOM_CLIENT], and [PROJET] are replaced with the entered values. Clear and maintainable VBA code: The code should be structured to allow easy addition or modification of options or fields in the future. Complete List of [OPTION ...] Tags: [OPTION JDF] [OPTION VOLIGEAGE] [OPTION BARDAGE AJOURE] [OPTION BARDAGE RL] [OPTION BARDAGE CLIN Partie fermée ou brise vue] [OPTION BARDAGE AJOURE Partie fermée ou brise vue] [OPTION OSSATURE Partie fermée] [OPTION TOITURE DEMI CROUPE] [OPTION TOITURE ŒIL DE B] [OPTION TOITURE TOITURE BETON] [OPTION TOITURE TOITURE TC] [OPTION TOITURE TOITURE ARDOISE ART] [OPTION TOITURE TOITURE ARDOISE N] [OPTION TOITURE TOITURE PANNEAU TUILE] [OPTION MONTAGE] [OPTION MACONNERIE] Technical Notes: The form should be generated dynamically to adapt to additional options or fields in the future. A scroll bar should be added if all the checkboxes cannot fit within the visible window. The form should open via a simple macro (e.g., AfficherUserForm). Expected Deliverables: A .docm file containing the VBA macro and a functional example based on a Word document template. A brief explanation of how the code works. Thank you for your valuable help. Please don’t hesitate to ask if you need clarification or additional details. Best regards,

Excel Auto filter

Hi All, a) I want to paste Raw client data into tab " Raw Data" in excel b) However I want the data automatically - when I flip over to the "Auto_Filtered_ClientData" tab to auto filter data i dont need to exclude eveything under a specific value ( in this case under 5) but to include Blanks and "-" C) once fitlered I also need it to sort it from Largest to Smallest in the Amount column of the Auto Filtered CLient data tab d) Any value in the amount column of "Auto_Filtered_ClientData" tab that has "-" or "#NA" this needs to be replaced with a zero "0". e) The Settings Tab - should be able to adjust values NOT to include each time ( so this can be adjusted in the future). I want to avoid Macro buttons , and VBA as much as possible (if at all?) - I just want to dump the raw data and then see the results populate automatically in the second tab "Auto_Filtered_ClientData" Thanks

Excel workbooks

I require the development of a sophisticated financial modelling solution for a construction company utilizing Excel. The overarching goal is to streamline cash flow forecasting and project costing processes. Specifically, the bidder will need to create a primary cash flow workbook that dynamically links to a secondary workbook to pull through updated financial data in real-time. Visualization of cash inflows and outflows over the project timeline will be integral. In addition, a robust pricing sheet is needed with intelligent linking capabilities. It must be able to read items from a master materials list andauto-populate values throughout various sheets for crafting accurate quotes. A further necessity is a workpack tool for drainage installation projects. This component should facilitate efficient planning and cost estimation of pipe laying, trenching and associated labour hours. Complex formulas will be required to derive material and labor costs based on supplied run lengths and installation details. The finished product demands a high degree of usability and flexibility. Intuitive interfaces and conditional formatting throughout are important. Ultimately, the solution will aim to significantlyboost productivity for estimating, budgeting and job cost control through an integrated Excel modelling approach. Professional verification of all formulas and links will also be expected. Fluency with Excel macros, VBA and array formulas combined with experience in the construction or project management fields would serve the bidder well in delivering this bespoke financial application successfully

Excel - Reconcilliation Sheet

Hi All , I am looking for part auto colour coding and part Data match reconcilliation sheet. After copying over data from the Client side in the "Client Raw Data" tab and my Company raw data in the "My Company Raw Data" tab in the results tab I want to try and match up the data to see where there is a break in the data set for me to investigate further. For the purpouse of making it easier to understand I have matched by line the client side and My company side results in the "Results" tab - however this my not be organised this way, as data on both side could be unfiltered or sorted or lines missing. So this is just so it is easier to view. I need a) Where there is a match for the cells to go green b) Company Name match - this is based off if the name fully matches on both the client side and mine or if an alternative name matches e.g Client name is Delta on the company side , however on my company side it shows as Delta 1. It has to search the Alternate name tab - to see if the alternate name matches or not? c) where there is an amount only match for example a message should appear in the Amount match cell " Exact amount found only) - thus I would need to investigate further. d) I need the colour coding as per the example - this is to help me work though the data and errors quickly as possible. I dont want to use macros or VBA - as I want to try and replicate this my self by looking at the formulas and colour coding myself. Thanks

Telemarketing Macro Program Development Note to Developers

Note to Developers We are seeking developers who have previous experience in building similar macro programs. Please submit bids with realistic development costs. 1. Project Objective Develop a telemarketing macro program that automates call initiation and SMS messaging. The goal is to enable efficient call management and large-scale communication. 2. Main Features and Requirements Multilingual Support The program must support both English and Korean, with all UI elements available in both languages. Language switching should be available in real time. Call Functionality Caller ID Format: The caller ID should follow the Korean mobile phone number format (e.g., 010-0000-0000). Call Start/End Time Settings: Call start and end times can be set in seconds within a 24-hour window. Repetitive Call Interval Settings: Call intervals and end intervals are to be set in seconds. All settings can be adjusted in seconds. Random Interval Settings: The ability to set both fixed and random intervals for calls and SMS dispatch. Caller ID Change Feature: The caller ID must change randomly for each call from a predefined list of numbers. Bulk Call Settings: The program should support bulk calling of up to 100 calls at once, with appropriate intervals to distribute load. SMS Sending Feature Simultaneous SMS Sending: Support for sending up to 200-300 SMS messages at once, with intervals between sends to distribute load. SMS Sender Number Management: The sender's number should change automatically for each SMS. SMS Start/End Time Settings: SMS dispatch times can be set in seconds within a 24-hour window. Communication Scheduling and Limits Holiday Settings: Calls and SMS dispatch are automatically suspended on specific days (e.g., weekends, holidays). Budget Control: Set daily maximum limits for call and SMS volume to avoid excessive use. Real-Time Alerts and Error Handling Real-Time Alerts: Receive alerts via in-app pop-ups when specific conditions are met (e.g., successful dispatch, failure). Automatic Retry: If an error occurs during call or SMS dispatch, the program should automatically retry the action. The user should also have the ability to pause or stop ongoing tasks. API Integration Twilio API and AWS Usage: Integrate Twilio and AWS for reliable call and SMS functionalities. Data Management and Analysis Data Storage and Editing: Phone number contact data should be editable in real time within the program and saved in CSV format for easy management. Real-Time Dashboard: Provide a real-time dashboard that monitors the success and failure rates of calls and SMS messages, along with detailed success/failure reasons after dispatch (e.g., 'Success: 95 calls, Failure: 5 calls'). User Interface (UI) Intuitive UI: Include intuitive controls like sliders and dropdown menus, allowing users to easily adjust settings. Add the capability for users to schedule call and SMS tasks and provide a UI for easy management of these schedules. Scalability Consideration Although currently designed for a single user, the program should be built with the flexibility to scale to a web-based solution or integrate with additional communication services if needed. User Access Management The program allows only one user to log in at a time, with no lock feature for data being accessed concurrently. Log Records Log records of internal program operations are optional and can be added as needed. User Manual and Tutorials Provide a simple user manual and tutorials to help users easily understand and operate the program.

urgent

Website scrape test: scrape just seven items from a website

I have a web scraping project. It's quite urgent but I think it is fairly straightforward and may even be possible using the Excel Power Query. There are no password issues and all data is publicly available. I am including to a link to a video for my client web site that shows the process to select the scrape data. Please view this before responding https://www.dropbox.com/scl/fi/n7xda6xvlq2x7e2h4u3or/Website.mp4?rlkey=t2sde1e5qaef6jl3gxrnlmwj2&dl=0 The client sells hundreds of different paint products from different manufacturers. This project is a proof of concept to prove that you can provide an automatic solution and acceptable output format to scrape just 7 of the products. Each Manufacturer supplies Product and Safety Sheets for the product. In most cases the Manufacturer sheets are downloadable via a link to the Manufacturer's site. Sometimes the client has the sheet stored in their own db. The client wants to scrape the website to be able to download every sheet into a single directory and produce an Excel sheet that has an index of the different products and also shows the url trail from the website. The sheet may have a completely different name from the website so we need to be able to index every sheet and be able to retrieve it. If this is something you are interested in I need you to prove the process with the following very simple Test Project ... To prove the concept and output formats I want you to just scrape the Product and Safety sheets for the seven paints in the Anti-Condensation category shown in the attached video tonight? We are only interested in the Product and Safety sheets. Some products have other sheets - we are not interested in these. Some products may have several Safety sheets we are interested in all the Safety sheets. Let me know if you think it can be done in Excel, a mix of Excel/Macros/VBA or using an alternative solution (and let me know what your alternative is). If you are successful with this project I will then create a new project to scrape the whole site. You must have excellent written English and preferably a track record of at least a dozen similar projects Please start your reply with the word Blackpool so that I know you have read to the end. ... and please dont just send some auto AI response. I am getting a bit tired of these Best of luck Chris